ag-grid-enterprise

What is ag-grid-enterprise?

The ag-grid-enterprise npm package is a powerful data grid component for JavaScript frameworks like Angular, React, and Vue. It provides advanced features for data manipulation, visualization, and interaction, making it suitable for enterprise-level applications.

What are ag-grid-enterprise's main functionalities?

Pivoting

Pivoting allows you to dynamically change the structure of your data, summarizing it in a way that makes it easier to analyze. The code sample demonstrates how to enable pivot mode and define pivot columns.

const gridOptions = {
  columnDefs: [
    { field: 'athlete', pivot: true },
    { field: 'age' },
    { field: 'country' },
    { field: 'year' },
    { field: 'date' },
    { field: 'sport' },
    { field: 'gold' },
    { field: 'silver' },
    { field: 'bronze' },
    { field: 'total' }
  ],
  pivotMode: true,
  rowData: null // set row data here
};

Row Grouping

Row Grouping allows you to group rows based on the values of one or more columns. The code sample shows how to enable row grouping for the 'country' and 'year' columns.

const gridOptions = {
  columnDefs: [
    { field: 'athlete' },
    { field: 'age' },
    { field: 'country', rowGroup: true },
    { field: 'year', rowGroup: true },
    { field: 'date' },
    { field: 'sport' },
    { field: 'gold' },
    { field: 'silver' },
    { field: 'bronze' },
    { field: 'total' }
  ],
  rowData: null // set row data here
};

Aggregation

Aggregation allows you to perform calculations on your data, such as summing up values. The code sample demonstrates how to set up aggregation functions for the 'gold', 'silver', 'bronze', and 'total' columns.

const gridOptions = {
  columnDefs: [
    { field: 'athlete' },
    { field: 'age' },
    { field: 'country' },
    { field: 'year' },
    { field: 'date' },
    { field: 'sport' },
    { field: 'gold', aggFunc: 'sum' },
    { field: 'silver', aggFunc: 'sum' },
    { field: 'bronze', aggFunc: 'sum' },
    { field: 'total', aggFunc: 'sum' }
  ],
  rowData: null // set row data here
};

Excel Export

Excel Export allows you to export your grid data to an Excel file. The code sample shows how to trigger an Excel export when the grid is ready.

const gridOptions = {
  columnDefs: [
    { field: 'athlete' },
    { field: 'age' },
    { field: 'country' },
    { field: 'year' },
    { field: 'date' },
    { field: 'sport' },
    { field: 'gold' },
    { field: 'silver' },
    { field: 'bronze' },
    { field: 'total' }
  ],
  rowData: null, // set row data here
  onGridReady: function(params) {
    params.api.exportDataAsExcel();
  }
};

Other packages similar to ag-grid-enterprise

handsontable

Handsontable is a JavaScript data grid component with a spreadsheet-like interface. It offers features like data validation, sorting, filtering, and CRUD operations. Compared to ag-grid-enterprise, Handsontable has a more Excel-like user experience but may lack some of the advanced enterprise features like pivoting and complex aggregation.

react-table

React Table is a lightweight, fast, and extendable data grid built specifically for React. It provides basic features like sorting, filtering, and pagination. While it is highly customizable and easy to use, it does not offer as many built-in advanced features as ag-grid-enterprise, such as pivoting and Excel export.

slickgrid

SlickGrid is a JavaScript grid/spreadsheet component that offers high performance and a rich set of features like column resizing, reordering, and custom cell formatting. It is highly customizable but requires more effort to set up and configure compared to ag-grid-enterprise.

README

ag-Grid-Enterprise

This project contains ag-Grid-Enterprise features.

See www.ag-grid.com.

This is not free software, this software is covered by copyright and to use you need a commercial license.

Please see files: LICENSE.md SUPPORT_AND_MAINTENANCE.md

Building

To build:

• npm install
• npm install gulp -g
• gulp or gulp release